Courses Offered: SCJP SCWCD Design patterns EJB CORE JAVA AJAX Adv. Java XML STRUTS Web services SPRING HIBERNATE  

       

SQL Server with SSRS Course Details
 

Subcribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date:Oct 1st @ 12:00PM

Faculty: Mr. Mohan Reddy

Duration : 30 Day's

Location : Maitrivanam, Hyderabad.

Venue :
DURGA SOFTWARE SOLUTIONS at Maitrivanam
Plot No : 202,
IInd Floor ,
HUDA Maitrivanam,
Ameerpet, Hyderabad-500038.
Ph.No : 09246212143, 80 96 96 96 96, 040-64512786

Syllabus:

I. Concepts

  • Database concepts
  • RDBMS Concepts
  • Data ModelsConstraints Normalization- 1NF,2NF,3NF,BCNF etc
  • ER Diagrams

Sql Server Concepts

  • Introduction to Sql Server 2008 R2

Sql Server 2008 Features

  • Server typesEditionsComponentsManagement StudioT-SQL FeaturesNew Operators
  • DML Statements

T-SQL

  • DDLData TypesSystem Defined data typesUser defined DataCreate/modify/delete tablesCreate/modify/delete tablesOperatorsDMLDCL
  • Using Select Statement

Maintaining Database Integrity

  • Constraints  RulesEntity IntegrityDomain Integrity
  • Referential Integrity

Sub Queries

  • Built-in functionNested sub queriesCorrelated sub queriesDerived tablesRecursive queries
  • Common table expression

Joins

  • Cross join, inner join, self join, outer join

Indexes

  • Types of IndexesCreating indexesModifying indexes
  • Dropping indexes

Views

  • About ViewCreating ViewsAltering ViewsMaterialized  views
  • Distributed view

Stored Procedures

  • AdvantagesSystem stored proceduresExtended stored procedures
  • Parameter handling

User Defined functions

  • Returning scalar valueReturning table of dataDeterministic functions
  • Non deterministic functions

Triggers

  • Constraints Vs triggersAfter triggersInstead of TriggerDDL triggers
  • Altering and Dropping Triggers

Cursors

  • Select Vs CursorsTypes of CursorsCreating CursorsOpen/fetch/close cursors
  • Using cursors in Stored procedures and Triggers.

Microsoft  .NET Frame Work Integration

  • CLR integrationUDAUDFStored Procedures
  • Triggers

Transactions and locks

  • ACID propertiesImplicit TransactionsExplicit TransactionsTransaction processConcurrency problemsLock TypesDistributed Transactions
  • Dead Locks

Data Transformation services

  • BCP
  • DTS

Administrative tasks

  • Creating databaseCopy, maintaining databaseSecurity conceptsSchemas, permissions
  • Backup and Restore database

Sql Server AgentSql Server ProfilerDatabase Engine Tuning Adviser

Sql Server Management Objects

  • Programming with SMOConnecting to Sql Server
  • Scripting

XML in Sql Server
Working with Images
Introduction to MS- BI

  • SSRSStandard, Ad- hoc Embedded ReportsSSIS
  • SSAS

Sql Server 2012 Features

  • SequenceOFFSET and FETCH
  • WITH RESULT SETS in stored procedure
    THROW in triggers

Sql Server 2014 features